Overview

Dataset info

Number of variables51
Number of observations462298
Missing cells2183512 (9.3%)
Duplicate rows0 (0.0%)
Total size in memory179.9 MiB
Average record size in memory408.0 B

Variables types

Numeric12
Categorical17
Boolean15
Date0
URL0
Text (Unique)1
Rejected6
Unsupported0

Warnings

de_faixa_faturamento_estimado has 27513 (6.0%) missing values Missing
de_faixa_faturamento_estimado_grupo has 27513 (6.0%) missing values Missing
de_natureza_juridica has a high cardinality: 67 distinct values Warning
de_nivel_atividade has 11168 (2.4%) missing values Missing
de_saude_rescencia has 14851 (3.2%) missing values Missing
de_saude_tributaria has 14851 (3.2%) missing values Missing
dt_situacao has a high cardinality: 7335 distinct values Warning
empsetorcensitariofaixarendapopulacao has 143829 (31.1%) missing values Missing
fl_optante_simei is highly correlated with fl_mei (ρ = 0.9579210437) Rejected
fl_optante_simples has 82713 (17.9%) missing values Missing
idade_maxima_socios has 151602 (32.8%) missing values Missing
idade_media_socios is highly correlated with idade_maxima_socios (ρ = 0.9568741341) Rejected
idade_minima_socios is highly correlated with idade_media_socios (ρ = 0.9533591208) Rejected
nm_divisao has a high cardinality: 88 distinct values Warning
nm_meso_regiao has 58698 (12.7%) missing values Missing
nm_micro_regiao has a high cardinality: 74 distinct values Warning
nm_micro_regiao has 58698 (12.7%) missing values Missing
nu_meses_rescencia has 45276 (9.8%) missing values Missing
qt_filiais has 418043 (90.4%) zeros Zeros
qt_socios is highly skewed (γ1 = 27.25083606) Skewed
qt_socios has 115091 (24.9%) missing values Missing
qt_socios_feminino is highly skewed (γ1 = 76.48075241) Skewed
qt_socios_feminino has 317269 (68.6%) missing values Missing
qt_socios_masculino is highly correlated with qt_socios (ρ = 0.9632367436) Rejected
qt_socios_pf is highly correlated with qt_socios_masculino (ρ = 0.9652540624) Rejected
qt_socios_pj has 342663 (74.1%) zeros Zeros
qt_socios_pj has 115091 (24.9%) missing values Missing
qt_socios_st_regular is highly correlated with qt_socios_pf (ρ = 0.9883617721) Rejected
vl_faturamento_estimado_aux is highly skewed (γ1 = 329.062977) Skewed
vl_faturamento_estimado_aux has 27513 (6.0%) missing values Missing
vl_faturamento_estimado_grupo_aux is highly skewed (γ1 = 26.79710656) Skewed
vl_faturamento_estimado_grupo_aux has 27513 (6.0%) missing values Missing
vl_total_veiculos_leves_grupo is highly skewed (γ1 = 34.48790893) Skewed
vl_total_veiculos_leves_grupo has 424180 (91.8%) zeros Zeros
vl_total_veiculos_pesados_grupo is highly skewed (γ1 = 31.26208196) Skewed
vl_total_veiculos_pesados_grupo has 441360 (95.5%) zeros Zeros

Variables

de_faixa_faturamento_estimado
Categorical

Distinct count13
Unique (%)< 0.1%
Missing (%)6.0%
Missing (n)27513
DE R$ 81.000,01 A R$ 360.000,00
273861
ATE R$ 81.000,00
98558
DE R$ 360.000,01 A R$ 1.500.000,00
 
46225
Other values (9)
 
16141
(Missing)
 
27513
ValueCountFrequency (%) 
DE R$ 81.000,01 A R$ 360.000,00 273861 59.2%
 
ATE R$ 81.000,00 98558 21.3%
 
DE R$ 360.000,01 A R$ 1.500.000,00 46225 10.0%
 
DE R$ 1.500.000,01 A R$ 4.800.000,00 10153 2.2%
 
DE R$ 4.800.000,01 A R$ 10.000.000,00 2150 0.5%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 1445 0.3%
 
SEM INFORMACAO 1173 0.3%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 871 0.2%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 253 0.1%
 
DE R$ 300.000.000,01 A R$ 500.000.000,00 48 < 0.1%
 
Other values (2) 48 < 0.1%
 
(Missing) 27513 6.0%
 
Max length40
Mean length26.5734072
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_faixa_faturamento_estimado_grupo
Categorical

Distinct count12
Unique (%)< 0.1%
Missing (%)6.0%
Missing (n)27513
DE R$ 81.000,01 A R$ 360.000,00
252602
ATE R$ 81.000,00
98118
DE R$ 360.000,01 A R$ 1.500.000,00
53492
Other values (8)
 
30573
(Missing)
 
27513
ValueCountFrequency (%) 
DE R$ 81.000,01 A R$ 360.000,00 252602 54.6%
 
ATE R$ 81.000,00 98118 21.2%
 
DE R$ 360.000,01 A R$ 1.500.000,00 53492 11.6%
 
DE R$ 1.500.000,01 A R$ 4.800.000,00 13465 2.9%
 
DE R$ 4.800.000,01 A R$ 10.000.000,00 4055 0.9%
 
ACIMA DE 1 BILHAO DE REAIS 3613 0.8%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 3598 0.8%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 3061 0.7%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 1583 0.3%
 
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS 676 0.1%
 
(Missing) 27513 6.0%
 
Max length40
Mean length26.8179248
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_natureza_juridica
Categorical

Distinct count67
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
EMPRESARIO INDIVIDUAL
295756
SOCIEDADE EMPRESARIA LIMITADA
91231
ASSOCIACAO PRIVADA
 
29694
Other values (64)
 
45617
ValueCountFrequency (%) 
EMPRESARIO INDIVIDUAL 295756 64.0%
 
SOCIEDADE EMPRESARIA LIMITADA 91231 19.7%
 
ASSOCIACAO PRIVADA 29694 6.4%
 
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA 15183 3.3%
 
ORGAO DE DIRECAO LOCAL DE PARTIDO POLITICO 7301 1.6%
 
ORGANIZACAO RELIGIOSA 2908 0.6%
 
SOCIEDADE ANONIMA FECHADA 2196 0.5%
 
CONDOMINIO EDILICIO 2084 0.5%
 
ENTIDADE SINDICAL 1763 0.4%
 
CANDIDATO A CARGO POLITICO ELETIVO 1617 0.3%
 
Other values (57) 12565 2.7%
 
Max length70
Mean length24.49725069
Min length9
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_nivel_atividade
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)2.4%
Missing (n)11168
MEDIA
217949
ALTA
152245
BAIXA
76080
(Missing)
 
11168
ValueCountFrequency (%) 
MEDIA 217949 47.1%
 
ALTA 152245 32.9%
 
BAIXA 76080 16.5%
 
MUITO BAIXA 4856 1.1%
 
(Missing) 11168 2.4%
 
Max length11
Mean length4.685386915
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_ramo
Categorical

Distinct count33
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
COMERCIO VAREJISTA
172404
SERVICOS DIVERSOS
60318
SERVICOS DE ALOJAMENTO/ALIMENTACAO
 
30180
Other values (30)
199396
ValueCountFrequency (%) 
COMERCIO VAREJISTA 172404 37.3%
 
SERVICOS DIVERSOS 60318 13.0%
 
SERVICOS DE ALOJAMENTO/ALIMENTACAO 30180 6.5%
 
INDUSTRIA DA CONSTRUCAO 25363 5.5%
 
COMERCIO E REPARACAO DE VEICULOS 22356 4.8%
 
SERVICOS ADMINISTRATIVOS 21326 4.6%
 
BENS DE CONSUMO 21227 4.6%
 
SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS 17371 3.8%
 
COMERCIO POR ATACADO 16464 3.6%
 
TRANSPORTE, ARMAZENAGEM E CORREIO 15485 3.3%
 
Other values (23) 59804 12.9%
 
Max length49
Mean length22.05983154
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_saude_rescencia
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)3.2%
Missing (n)14851
ACIMA DE 1 ANO
378896
ATE 1 ANO
 
38101
SEM INFORMACAO
 
30425
Other values (2)
 
25
(Missing)
 
14851
ValueCountFrequency (%) 
ACIMA DE 1 ANO 378896 82.0%
 
ATE 1 ANO 38101 8.2%
 
SEM INFORMACAO 30425 6.6%
 
ATE 3 MESES 13 < 0.1%
 
ATE 6 MESES 12 < 0.1%
 
(Missing) 14851 3.2%
 
Max length14
Mean length13.23438778
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_saude_tributaria
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)3.2%
Missing (n)14851
VERDE
145430
AZUL
105230
AMARELO
91045
Other values (3)
105742
ValueCountFrequency (%) 
VERDE 145430 31.5%
 
AZUL 105230 22.8%
 
AMARELO 91045 19.7%
 
CINZA 64019 13.8%
 
LARANJA 36116 7.8%
 
VERMELHO 5607 1.2%
 
(Missing) 14851 3.2%
 
Max length8
Mean length5.294638956
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

dt_situacao
Categorical

Distinct count7335
Unique (%)1.6%
Missing (%)< 0.1%
Missing (n)6
2005-11-03
 
69465
2006-12-21
 
2207
2006-12-01
 
2018
Other values (7331)
388602
ValueCountFrequency (%) 
2005-11-03 69465 15.0%
 
2006-12-21 2207 0.5%
 
2006-12-01 2018 0.4%
 
2010-05-15 1799 0.4%
 
2005-09-24 1523 0.3%
 
1998-07-28 1490 0.3%
 
2006-12-02 1436 0.3%
 
2005-08-27 1391 0.3%
 
2004-10-30 954 0.2%
 
2001-07-01 892 0.2%
 
Other values (7324) 379117 82.0%
 
Max length10
Mean length9.99990915
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

empsetorcensitariofaixarendapopulacao
Numeric

Distinct count15420
Unique (%)3.3%
Missing (%)31.1%
Missing (n)143829
Infinite (%)0.0%
Infinite (n)0
Mean1308.005725
Minimum100
Maximum75093.84
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum100
5-th percentile424.28
Q1673.23
Median946.68
Q31518.08
95-th percentile3516.99
Maximum75093.84
Range74993.84
Interquartile range844.85

Descriptive statistics

Standard deviation1161.889222
Coef of variation0.8882906242
Kurtosis397.288486
Mean1308.005725
MAD721.2561603
Skewness9.232437997
Sum416559275.1
Variance1349986.563
Memory size3.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1549.1 1995 0.4%
 
2361.38 830 0.2%
 
1086.05 729 0.2%
 
3940.05 536 0.1%
 
3321.86 536 0.1%
 
2679.5 529 0.1%
 
3071.98 479 0.1%
 
786.74 456 0.1%
 
1910.81 447 0.1%
 
2019.39 445 0.1%
 
Other values (15409) 311487 67.4%
 
(Missing) 143829 31.1%
 

Minimum 5 values

ValueCountFrequency (%) 
100 3 < 0.1%
 
106.67 1 < 0.1%
 
107.7 1 < 0.1%
 
110.3 72 < 0.1%
 
130 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
75093.84 7 < 0.1%
 
30861.81 22 < 0.1%
 
15137.49 3 < 0.1%
 
13793 22 < 0.1%
 
12512.93 149 < 0.1%
 

fl_antt
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)1927
0
457095
1
 
3276
(Missing)
 
1927
ValueCountFrequency (%) 
0 457095 98.9%
 
1 3276 0.7%
 
(Missing) 1927 0.4%
 

fl_email
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
256228
1
206070
ValueCountFrequency (%) 
0 256228 55.4%
 
1 206070 44.6%
 

fl_ltda
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
461056
1
 
1242
ValueCountFrequency (%) 
0 461056 99.7%
 
1 1242 0.3%
 

fl_matriz
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
1
433232
0
 
29066
ValueCountFrequency (%) 
1 433232 93.7%
 
0 29066 6.3%
 

fl_me
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
461083
1
 
1215
ValueCountFrequency (%) 
0 461083 99.7%
 
1 1215 0.3%
 

fl_mei
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
311398
1
150900
ValueCountFrequency (%) 
0 311398 67.4%
 
1 150900 32.6%
 

fl_optante_simei
Highly correlated

This variable is highly correlated with fl_mei and should be ignored for analysis

Correlation0.9579210437

fl_optante_simples
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)17.9%
Missing (n)82713
1
199617
0
179968
(Missing)
82713
ValueCountFrequency (%) 
1 199617 43.2%
 
0 179968 38.9%
 
(Missing) 82713 17.9%
 

fl_passivel_iss
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)1927
1
264741
0
195630
(Missing)
 
1927
ValueCountFrequency (%) 
1 264741 57.3%
 
0 195630 42.3%
 
(Missing) 1927 0.4%
 

fl_rm
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
236779
1
225519
ValueCountFrequency (%) 
0 236779 51.2%
 
1 225519 48.8%
 

fl_sa
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
453866
1
 
8432
ValueCountFrequency (%) 
0 453866 98.2%
 
1 8432 1.8%
 

fl_simples_irregular
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)1927
0
460030
1
 
341
(Missing)
 
1927
ValueCountFrequency (%) 
0 460030 99.5%
 
1 341 0.1%
 
(Missing) 1927 0.4%
 

fl_spa
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)1927
0
460091
1
 
280
(Missing)
 
1927
ValueCountFrequency (%) 
0 460091 99.5%
 
1 280 0.1%
 
(Missing) 1927 0.4%
 

fl_st_especial
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
462230
1
 
68
ValueCountFrequency (%) 
0 462230 > 99.9%
 
1 68 < 0.1%
 

fl_telefone
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
1
335468
0
126830
ValueCountFrequency (%) 
1 335468 72.6%
 
0 126830 27.4%
 

fl_veiculo
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)1927
0
429687
1
 
30684
(Missing)
 
1927
ValueCountFrequency (%) 
0 429687 92.9%
 
1 30684 6.6%
 
(Missing) 1927 0.4%
 

id
Categorical, Unique

First 5 values
000001857eec66f7d67ea918825c9980eebff5c10b36f3...
0000133f443484b40bc632e3b8595c8348441b3899973f...
000047a124312a6e977ac8e37c677ae4eed7614d945996...
000061121bf1a98d79c02f156af0cadec80ea1c68236e6...
00009a58c6d16b1439d1918b27734c78283a7264e0ac1e...
Last 5 values
ffff6c0b13631b6bf0dc823675f8f54bf66552b8c87521...
ffff8882a623edc8a4b322217921aad8a3e84efacdaea1...
ffff989f6f3a687bcf883db3de06772544b625dcc29635...
ffff996a58acd0fc5e95b95edc812827b37fff57c3c239...
ffffd4fc4571772f61964cafe6c28a8d1fb8cec9103093...

First 5 values

ValueCountFrequency (%) 
000001857eec66f7d67ea918825c9980eebff5c10b36f3cbcf8b977dae2673f3 1 < 0.1%
 
0000133f443484b40bc632e3b8595c8348441b3899973f25a5375e915f84ef88 1 < 0.1%
 
000047a124312a6e977ac8e37c677ae4eed7614d9459968a48875a030c2bb31c 1 < 0.1%
 
000061121bf1a98d79c02f156af0cadec80ea1c68236e69c8a36d0b087878a78 1 < 0.1%
 
00009a58c6d16b1439d1918b27734c78283a7264e0ac1ed169baf5304b72f538 1 < 0.1%
 

Last 5 values

ValueCountFrequency (%) 
ffffd4fc4571772f61964cafe6c28a8d1fb8cec91030934be200aaec2d902161 1 < 0.1%
 
ffff996a58acd0fc5e95b95edc812827b37fff57c3c239f037cedf6cfb574dfb 1 < 0.1%
 
ffff989f6f3a687bcf883db3de06772544b625dcc29635ddaf631d7ba3dc6584 1 < 0.1%
 
ffff8882a623edc8a4b322217921aad8a3e84efacdaea101cfd23bceef91fb5a 1 < 0.1%
 
ffff6c0b13631b6bf0dc823675f8f54bf66552b8c87521bd419642465b05e304 1 < 0.1%
 

idade_emp_cat
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
1 a 5
138580
5 a 10
116100
> 20
75572
Other values (3)
132046
ValueCountFrequency (%) 
1 a 5 138580 30.0%
 
5 a 10 116100 25.1%
 
> 20 75572 16.3%
 
10 a 15 49205 10.6%
 
<= 1 46794 10.1%
 
15 a 20 36047 7.8%
 
Max length7
Mean length5.355264353
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

idade_empresa_anos
Numeric

Distinct count14198
Unique (%)3.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean9.948676561
Minimum0.01643835616
Maximum106.4328767
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.01643835616
5-th percentile0.4575342466
Q12.756164384
Median6.704109589
Q314.46575342
95-th percentile30.17808219
Maximum106.4328767
Range106.4164384
Interquartile range11.70958904

Descriptive statistics

Standard deviation9.615664247
Coef of variation0.9665269735
Kurtosis1.52217534
Mean9.948676561
MAD7.553130844
Skewness1.376723032
Sum4599253.277
Variance92.46099891
Memory size3.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[1.64383562e-02 2.19178082e-02 2.87671233e-02 3.69863014e-02 4.52054795e-02 ... 5.21219178e+01 5.22917808e+01 5.29986301e+01 5.67438356e+01 1.06432877e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0.2054794521 595 0.1%
 
0.2082191781 571 0.1%
 
0.202739726 470 0.1%
 
0.2164383562 322 0.1%
 
7.331506849 281 0.1%
 
0.2219178082 276 0.1%
 
6.317808219 271 0.1%
 
3.536986301 260 0.1%
 
3.534246575 257 0.1%
 
6.315068493 256 0.1%
 
Other values (14188) 458739 99.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0.01643835616 1 < 0.1%
 
0.02739726027 24 < 0.1%
 
0.0301369863 179 < 0.1%
 
0.03287671233 188 < 0.1%
 
0.03561643836 193 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
106.4328767 1 < 0.1%
 
89.44383562 1 < 0.1%
 
80.63835616 1 < 0.1%
 
77.52876712 1 < 0.1%
 
75.05479452 1 < 0.1%
 

idade_maxima_socios
Numeric

Distinct count119
Unique (%)< 0.1%
Missing (%)32.8%
Missing (n)151602
Infinite (%)0.0%
Infinite (n)0
Mean44.3441306
Minimum-2
Maximum127
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum-2
5-th percentile24
Q134
Median43
Q354
95-th percentile69
Maximum127
Range129
Interquartile range20

Descriptive statistics

Standard deviation13.93038532
Coef of variation0.3141427091
Kurtosis-0.0009405849143
Mean44.3441306
MAD11.33842405
Skewness0.5390117117
Sum13777544
Variance194.0556351
Memory size3.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
37 8925 1.9%
 
36 8906 1.9%
 
39 8721 1.9%
 
38 8699 1.9%
 
40 8686 1.9%
 
41 8591 1.9%
 
35 8500 1.8%
 
33 8306 1.8%
 
34 8095 1.8%
 
42 8089 1.7%
 
Other values (108) 225178 48.7%
 
(Missing) 151602 32.8%
 

Minimum 5 values

ValueCountFrequency (%) 
-2 1 < 0.1%
 
3 1 < 0.1%
 
4 2 < 0.1%
 
5 3 < 0.1%
 
6 5 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
127 1 < 0.1%
 
125 1 < 0.1%
 
123 1 < 0.1%
 
121 1 < 0.1%
 
120 1 < 0.1%
 

idade_media_socios
Highly correlated

This variable is highly correlated with idade_maxima_socios and should be ignored for analysis

Correlation0.9568741341

idade_minima_socios
Highly correlated

This variable is highly correlated with idade_media_socios and should be ignored for analysis

Correlation0.9533591208

natureza_juridica_macro
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
OUTROS
320211
ENTIDADES EMPRESARIAIS
99241
ENTIDADES SEM FINS LUCRATIVOS
 
37089
Other values (4)
 
5757
ValueCountFrequency (%) 
OUTROS 320211 69.3%
 
ENTIDADES EMPRESARIAIS 99241 21.5%
 
ENTIDADES SEM FINS LUCRATIVOS 37089 8.0%
 
ADMINISTRACAO PUBLICA 2912 0.6%
 
CARGO POLITICO 1617 0.3%
 
PESSOAS FISICAS 1225 0.3%
 
INSTITUICOES EXTRATERRITORIAIS 3 < 0.1%
 
Max length30
Mean length11.42640461
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_divisao
Categorical

Distinct count88
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)1927
COMERCIO VAREJISTA
172404
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS
 
37984
ALIMENTACAO
 
27540
Other values (84)
222443
ValueCountFrequency (%) 
COMERCIO VAREJISTA 172404 37.3%
 
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS 37984 8.2%
 
ALIMENTACAO 27540 6.0%
 
COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 22356 4.8%
 
COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS 16464 3.6%
 
OUTRAS ATIVIDADES DE SERVICOS PESSOAIS 15875 3.4%
 
SERVICOS ESPECIALIZADOS PARA CONSTRUCAO 14291 3.1%
 
TRANSPORTE TERRESTRE 11439 2.5%
 
EDUCACAO 11311 2.4%
 
SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO E OUTROS SERVICOS PRESTADOS PRINCIPALMENTE AS EMPRESAS 9726 2.1%
 
Other values (77) 120981 26.2%
 
Max length120
Mean length32.89757905
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_meso_regiao
Categorical

Distinct count20
Unique (%)< 0.1%
Missing (%)12.7%
Missing (n)58698
CENTRO AMAZONENSE
71469
NORTE MARANHENSE
61331
LESTE POTIGUAR
58762
Other values (16)
212038
(Missing)
58698
ValueCountFrequency (%) 
CENTRO AMAZONENSE 71469 15.5%
 
NORTE MARANHENSE 61331 13.3%
 
LESTE POTIGUAR 58762 12.7%
 
CENTRO NORTE PIAUIENSE 42244 9.1%
 
OESTE MARANHENSE 26796 5.8%
 
OESTE POTIGUAR 20860 4.5%
 
LESTE MARANHENSE 17651 3.8%
 
VALE DO ACRE 16539 3.6%
 
CENTRO MARANHENSE 13755 3.0%
 
SUDOESTE PIAUIENSE 12180 2.6%
 
Other values (9) 62013 13.4%
 
(Missing) 58698 12.7%
 
Max length22
Mean length14.58877174
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_micro_regiao
Categorical

Distinct count74
Unique (%)< 0.1%
Missing (%)12.7%
Missing (n)58698
MANAUS
60008
NATAL
 
46745
AGLOMERACAO URBANA DE SAO LUIS
 
45875
Other values (70)
250972
(Missing)
58698
ValueCountFrequency (%) 
MANAUS 60008 13.0%
 
NATAL 46745 10.1%
 
AGLOMERACAO URBANA DE SAO LUIS 45875 9.9%
 
TERESINA 33887 7.3%
 
IMPERATRIZ 15912 3.4%
 
RIO BRANCO 14064 3.0%
 
MOSSORO 10713 2.3%
 
PINDARE 8167 1.8%
 
MACAIBA 7318 1.6%
 
LITORAL PIAUIENSE 6816 1.5%
 
Other values (63) 154095 33.3%
 
(Missing) 58698 12.7%
 
Max length33
Mean length11.08048056
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_segmento
Categorical

Distinct count22
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)1927
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS
211224
OUTRAS ATIVIDADES DE SERVICOS
59561
INDUSTRIAS DE TRANSFORMACAO
 
31968
Other values (18)
157618
ValueCountFrequency (%) 
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 211224 45.7%
 
OUTRAS ATIVIDADES DE SERVICOS 59561 12.9%
 
INDUSTRIAS DE TRANSFORMACAO 31968 6.9%
 
ALOJAMENTO E ALIMENTACAO 30180 6.5%
 
CONSTRUCAO 25363 5.5%
 
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES 21326 4.6%
 
ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS 17371 3.8%
 
TRANSPORTE ARMAZENAGEM E CORREIO 15485 3.3%
 
EDUCACAO 11311 2.4%
 
SAUDE HUMANA E SERVICOS SOCIAIS 10139 2.2%
 
Other values (11) 26443 5.7%
 
Max length65
Mean length42.52199447
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nu_meses_rescencia
Numeric

Distinct count52
Unique (%)< 0.1%
Missing (%)9.8%
Missing (n)45276
Infinite (%)0.0%
Infinite (n)0
Mean25.00724662
Minimum0
Maximum66
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile9
Q122
Median23
Q325
95-th percentile48
Maximum66
Range66
Interquartile range3

Descriptive statistics

Standard deviation9.679799286
Coef of variation0.3870797707
Kurtosis1.945603876
Mean25.00724662
MAD5.88354324
Skewness1.261726999
Sum10428572
Variance93.69851423
Memory size3.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
23 108609 23.5%
 
22 89143 19.3%
 
24 44574 9.6%
 
48 26480 5.7%
 
25 25087 5.4%
 
26 24218 5.2%
 
27 18888 4.1%
 
21 12154 2.6%
 
7 10016 2.2%
 
47 9637 2.1%
 
Other values (41) 48216 10.4%
 
(Missing) 45276 9.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 4 < 0.1%
 
1 4 < 0.1%
 
2 5 < 0.1%
 
5 8 < 0.1%
 
6 4 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
66 41 < 0.1%
 
65 33 < 0.1%
 
64 4 < 0.1%
 
54 1560 0.3%
 
53 51 < 0.1%
 

qt_filiais
Numeric

Distinct count304
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean28.73704407
Minimum0
Maximum9647
Zeros (%)90.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile2
Maximum9647
Range9647
Interquartile range0

Descriptive statistics

Standard deviation468.6260942
Coef of variation16.30738684
Kurtosis356.9251027
Mean28.73704407
MAD56.06139032
Skewness18.6663858
Sum13285078
Variance219610.4161
Memory size3.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000e+00 5.0000e-01 1.5000e+00 2.5000e+00 3.5000e+00 ... 5.4670e+03 8.4785e+03 9.3405e+03 9.5290e+03 9.6470e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 418043 90.4%
 
1 19561 4.2%
 
2 5943 1.3%
 
3 2884 0.6%
 
4 1772 0.4%
 
5 1161 0.3%
 
6 818 0.2%
 
7 637 0.1%
 
8 544 0.1%
 
9 485 0.1%
 
Other values (294) 10450 2.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 418043 90.4%
 
1 19561 4.2%
 
2 5943 1.3%
 
3 2884 0.6%
 
4 1772 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
9647 265 0.1%
 
9411 281 0.1%
 
9270 373 0.1%
 
7687 191 < 0.1%
 
5491 106 < 0.1%
 

qt_socios
Numeric

Distinct count63
Unique (%)< 0.1%
Missing (%)24.9%
Missing (n)115091
Infinite (%)0.0%
Infinite (n)0
Mean1.496326399
Minimum1
Maximum246
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile3
Maximum246
Range245
Interquartile range1

Descriptive statistics

Standard deviation3.276626415
Coef of variation2.18978053
Kurtosis923.2237301
Mean1.496326399
MAD0.7386222867
Skewness27.25083606
Sum519535
Variance10.73628066
Memory size3.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 258353 55.9%
 
2 71030 15.4%
 
3 8902 1.9%
 
4 3214 0.7%
 
5 1612 0.3%
 
6 998 0.2%
 
8 749 0.2%
 
7 557 0.1%
 
9 300 0.1%
 
96 265 0.1%
 
Other values (52) 1227 0.3%
 
(Missing) 115091 24.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1 258353 55.9%
 
2 71030 15.4%
 
3 8902 1.9%
 
4 3214 0.7%
 
5 1612 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
246 1 < 0.1%
 
238 1 < 0.1%
 
199 1 < 0.1%
 
168 1 < 0.1%
 
165 1 < 0.1%
 

qt_socios_feminino
Numeric

Distinct count34
Unique (%)< 0.1%
Missing (%)68.6%
Missing (n)317269
Infinite (%)0.0%
Infinite (n)0
Mean1.107116508
Minimum1
Maximum140
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile2
Maximum140
Range139
Interquartile range0

Descriptive statistics

Standard deviation0.8401936523
Coef of variation0.7589026507
Kurtosis9249.637522
Mean1.107116508
MAD0.1980018315
Skewness76.48075241
Sum160564
Variance0.7059253734
Memory size3.5 MiB
Histogram
Histogram with fixed size bins (bins=34)
ValueCountFrequency (%) 
1 134041 29.0%
 
2 9084 2.0%
 
3 1247 0.3%
 
4 324 0.1%
 
5 133 < 0.1%
 
6 59 < 0.1%
 
7 30 < 0.1%
 
15 28 < 0.1%
 
9 23 < 0.1%
 
8 16 < 0.1%
 
Other values (23) 44 < 0.1%
 
(Missing) 317269 68.6%
 

Minimum 5 values

ValueCountFrequency (%) 
1 134041 29.0%
 
2 9084 2.0%
 
3 1247 0.3%
 
4 324 0.1%
 
5 133 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
140 1 < 0.1%
 
95 1 < 0.1%
 
93 1 < 0.1%
 
88 1 < 0.1%
 
74 1 < 0.1%
 

qt_socios_masculino
Highly correlated

This variable is highly correlated with qt_socios and should be ignored for analysis

Correlation0.9632367436

qt_socios_pf
Highly correlated

This variable is highly correlated with qt_socios_masculino and should be ignored for analysis

Correlation0.9652540624

qt_socios_pj
Numeric

Distinct count13
Unique (%)< 0.1%
Missing (%)24.9%
Missing (n)115091
Infinite (%)0.0%
Infinite (n)0
Mean0.01964534125
Minimum0
Maximum13
Zeros (%)74.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum13
Range13
Interquartile range0

Descriptive statistics

Standard deviation0.1951660243
Coef of variation9.934468524
Kurtosis362.7623512
Mean0.01964534125
MAD0.0387764738
Skewness14.78811156
Sum6821
Variance0.03808977704
Memory size3.5 MiB
Histogram
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%) 
0 342663 74.1%
 
1 2783 0.6%
 
2 1459 0.3%
 
3 193 < 0.1%
 
4 70 < 0.1%
 
5 14 < 0.1%
 
7 9 < 0.1%
 
6 6 < 0.1%
 
8 5 < 0.1%
 
9 3 < 0.1%
 
Other values (2) 2 < 0.1%
 
(Missing) 115091 24.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 342663 74.1%
 
1 2783 0.6%
 
2 1459 0.3%
 
3 193 < 0.1%
 
4 70 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
13 1 < 0.1%
 
12 1 < 0.1%
 
9 3 < 0.1%
 
8 5 < 0.1%
 
7 9 < 0.1%
 

qt_socios_st_regular
Highly correlated

This variable is highly correlated with qt_socios_pf and should be ignored for analysis

Correlation0.9883617721

setor
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)1927
COMERCIO
211224
SERVIÇO
189644
INDUSTRIA
 
30893
Other values (2)
 
28610
ValueCountFrequency (%) 
COMERCIO 211224 45.7%
 
SERVIÇO 189644 41.0%
 
INDUSTRIA 30893 6.7%
 
CONSTRUÇÃO CIVIL 25363 5.5%
 
AGROPECUARIA 3247 0.7%
 
(Missing) 1927 0.4%
 
Max length16
Mean length8.102760557
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

sg_uf
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
MA
127654
RN
98837
AM
82114
Other values (3)
153693
ValueCountFrequency (%) 
MA 127654 27.6%
 
RN 98837 21.4%
 
AM 82114 17.8%
 
PI 76686 16.6%
 
RO 56469 12.2%
 
AC 20538 4.4%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sg_uf_matriz
Categorical

Distinct count28
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)1939
MA
124823
RN
96743
AM
80032
Other values (24)
158761
ValueCountFrequency (%) 
MA 124823 27.0%
 
RN 96743 20.9%
 
AM 80032 17.3%
 
PI 75201 16.3%
 
RO 54876 11.9%
 
AC 20028 4.3%
 
SP 2845 0.6%
 
DF 1225 0.3%
 
CE 927 0.2%
 
RJ 669 0.1%
 
Other values (17) 2990 0.6%
 
(Missing) 1939 0.4%
 
Max length3
Mean length2.004194264
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

vl_faturamento_estimado_aux
Numeric

Distinct count1921
Unique (%)0.4%
Missing (%)6.0%
Missing (n)27513
Infinite (%)0.0%
Infinite (n)0
Mean802091.1378
Minimum0
Maximum1.4546625e+10
Zeros (%)0.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile50000
Q1164851.2
Median210000
Q3210000
95-th percentile989107.2
Maximum1.4546625e+10
Range1.4546625e+10
Interquartile range45148.8

Descriptive statistics

Standard deviation30999788.42
Coef of variation38.6487108
Kurtosis137216.1313
Mean802091.1378
MAD1119630.467
Skewness329.062977
Sum3.487371953e+11
Variance9.609868822e+14
Memory size3.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
210000 249868 54.0%
 
50000 94137 20.4%
 
930000 16075 3.5%
 
185457.6 8252 1.8%
 
370915.2 6489 1.4%
 
123638.4 6357 1.4%
 
247276.8 3920 0.8%
 
556372.8 2901 0.6%
 
741830.4 2853 0.6%
 
61819.2 2162 0.5%
 
Other values (1910) 41771 9.0%
 
(Missing) 27513 6.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1173 0.3%
 
41047.03 1 < 0.1%
 
41212.8 1923 0.4%
 
50000 94137 20.4%
 
51516 335 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.4546625e+10 1 < 0.1%
 
9961906000 1 < 0.1%
 
3490930200 1 < 0.1%
 
3220831700 1 < 0.1%
 
2669847000 1 < 0.1%
 

vl_faturamento_estimado_grupo_aux
Numeric

Distinct count6795
Unique (%)1.5%
Missing (%)6.0%
Missing (n)27513
Infinite (%)0.0%
Infinite (n)0
Mean336720529.8
Minimum41047.03
Maximum2.227618e+11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum41047.03
5-th percentile50000
Q1185457.6
Median210000
Q3210000
95-th percentile2843683.2
Maximum2.227618e+11
Range2.22761759e+11
Interquartile range24542.4

Descriptive statistics

Standard deviation7114614457
Coef of variation21.12913775
Kurtosis756.5828773
Mean336720529.8
MAD662945084.1
Skewness26.79710656
Sum1.464010356e+14
Variance5.061773887e+19
Memory size3.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
210000 230845 49.9%
 
50000 94137 20.4%
 
930000 12789 2.8%
 
185457.6 7149 1.5%
 
420000 6916 1.5%
 
123638.4 5696 1.2%
 
370915.2 5573 1.2%
 
247276.8 3415 0.7%
 
741830.4 2396 0.5%
 
556372.8 2391 0.5%
 
Other values (6784) 63478 13.7%
 
(Missing) 27513 6.0%
 

Minimum 5 values

ValueCountFrequency (%) 
41047.03 1 < 0.1%
 
41212.8 1774 0.4%
 
50000 94137 20.4%
 
51516 308 0.1%
 
61819.2 1898 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
2.227618e+11 191 < 0.1%
 
1.8943014e+11 265 0.1%
 
1.8120853e+11 26 < 0.1%
 
1.2398112e+11 9 < 0.1%
 
1.009873e+11 15 < 0.1%
 

vl_total_veiculos_leves_grupo
Numeric

Distinct count311
Unique (%)0.1%
Missing (%)0.4%
Missing (n)1927
Infinite (%)0.0%
Infinite (n)0
Mean48.6991774
Minimum0
Maximum122090
Zeros (%)91.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum122090
Range122090
Interquartile range0

Descriptive statistics

Standard deviation1206.696804
Coef of variation24.77858699
Kurtosis1614.685275
Mean48.6991774
MAD95.963728
Skewness34.48790893
Sum22419689
Variance1456117.176
Memory size3.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 424180 91.8%
 
1 15738 3.4%
 
2 5232 1.1%
 
3 2610 0.6%
 
4 1569 0.3%
 
5 1099 0.2%
 
6 781 0.2%
 
7 618 0.1%
 
8 512 0.1%
 
10 408 0.1%
 
Other values (300) 7624 1.6%
 
(Missing) 1927 0.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 424180 91.8%
 
1 15738 3.4%
 
2 5232 1.1%
 
3 2610 0.6%
 
4 1569 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
122090 2 < 0.1%
 
105312 2 < 0.1%
 
96763 2 < 0.1%
 
57941 2 < 0.1%
 
44250 1 < 0.1%
 

vl_total_veiculos_pesados_grupo
Numeric

Distinct count297
Unique (%)0.1%
Missing (%)0.4%
Missing (n)1927
Infinite (%)0.0%
Infinite (n)0
Mean3.591800961
Minimum0
Maximum9782
Zeros (%)95.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum9782
Range9782
Interquartile range0

Descriptive statistics

Standard deviation72.60035227
Coef of variation20.21279939
Kurtosis1491.122182
Mean3.591800961
MAD6.98457279
Skewness31.26208196
Sum1653561
Variance5270.81115
Memory size3.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 441360 95.5%
 
1 6785 1.5%
 
2 2585 0.6%
 
3 1301 0.3%
 
4 827 0.2%
 
5 653 0.1%
 
7 532 0.1%
 
6 487 0.1%
 
1177 373 0.1%
 
95 283 0.1%
 
Other values (286) 5185 1.1%
 
(Missing) 1927 0.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 441360 95.5%
 
1 6785 1.5%
 
2 2585 0.6%
 
3 1301 0.3%
 
4 827 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
9782 1 < 0.1%
 
3674 2 < 0.1%
 
3484 1 < 0.1%
 
2710 2 < 0.1%
 
2693 5 < 0.1%
 

Correlations

Missing values

Sample

First rows

de_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofl_anttfl_emailfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculoididade_emp_catidade_empresa_anosidade_maxima_sociosidade_media_sociosidade_minima_sociosnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciaqt_filiaisqt_sociosqt_socios_femininoqt_socios_masculinoqt_socios_pfqt_socios_pjqt_socios_st_regularsetorsg_ufsg_uf_matrizvl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_total_veiculos_leves_grupovl_total_veiculos_pesados_grupo
0DE R$ 1.500.000,01 A R$ 4.800.000,00DE R$ 1.500.000,01 A R$ 4.800.000,00SOCIEDADE EMPRESARIA LIMITADAALTAINDUSTRIA DA CONSTRUCAOACIMA DE 1 ANOVERDE2005-03-25NaN0.0101000.01.01.0100.00.0010.0a6984c3ae395090e3bee8ad63c3758b110de096d5d8195...10 a 1514.45753447.044.041.0ENTIDADES EMPRESARIAISCONSTRUCAO DE EDIFICIOSLESTE POTIGUARNATALCONSTRUCAO23.002.0NaN2.02.00.02.0CONSTRUÇÃO CIVILRNRN3132172.83132172.80.00.0
1DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00EMPRESARIO INDIVIDUALBAIXASERVICOS DE ALOJAMENTO/ALIMENTACAOATE 1 ANOCINZA2017-05-12468.930.010101NaNNaN1.0100.00.0010.06178f41ade1365e44bc2c46654c2c8c0eaae27dcb476c4...1 a 51.46301427.027.027.0OUTROSALIMENTACAOCENTRO NORTE PIAUIENSETERESINAALOJAMENTO E ALIMENTACAO9.001.0NaN1.01.00.01.0SERVIÇOPIPI210000.0210000.00.00.0
2ATE R$ 81.000,00ATE R$ 81.000,00EMPRESARIO INDIVIDUALMEDIATRANSPORTE, ARMAZENAGEM E CORREIOACIMA DE 1 ANOAMARELO2011-09-26713.500.0001011.01.01.0100.00.0010.04a7e5069a397f12fdd7fd57111d6dc5d3ba558958efc02...5 a 107.09315132.032.032.0OUTROSTRANSPORTE TERRESTRECENTRO AMAZONENSEMANAUSTRANSPORTE ARMAZENAGEM E CORREIO26.001.0NaN1.01.00.0NaNSERVIÇOAMAM50000.050000.00.00.0
3DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00EMPRESARIO INDIVIDUALMEDIASERVICOS DIVERSOSACIMA DE 1 ANOAMARELO2012-04-25475.730.0101000.01.01.0100.00.0010.03348900fe63216a439d2e5238c79ddd46ede454df7b9d8...5 a 106.51232936.036.036.0OUTROSREPARACAO E MANUTENCAO DE EQUIPAMENTOS DE INFO...CENTRO AMAZONENSEMANAUSOUTRAS ATIVIDADES DE SERVICOS26.001.0NaN1.01.00.01.0SERVIÇOAMAM210000.0210000.00.00.0
4DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00EMPRESARIO INDIVIDUALALTASERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOSACIMA DE 1 ANOVERDE2015-08-172874.040.0101000.01.01.0100.00.0010.01f9bcabc9d3173c1fe769899e4fac14b053037b953a1e4...1 a 53.200000NaNNaNNaNOUTROSSERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ...LESTE POTIGUARNATALATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS27.001.0NaNNaN1.00.0NaNSERVIÇORNRN210000.0210000.00.00.0
5DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00SOCIEDADE EMPRESARIA LIMITADAALTAQUIMICA-PETROQUIMICAACIMA DE 1 ANOLARANJA2005-11-03NaN0.0001000.00.00.0000.00.0000.0529a1f5fc6f88071db7d38492a0ce7c985c77e9b1c3bb6...> 2038.079452NaNNaNNaNENTIDADES EMPRESARIAISFABRICACAO DE PRODUTOS DE MINERAIS NAO METALICOSOESTE POTIGUARPAU DOS FERROSINDUSTRIAS DE TRANSFORMACAO48.00NaNNaNNaNNaNNaNNaNINDUSTRIARNRN210000.0210000.00.00.0
6ATE R$ 81.000,00ATE R$ 81.000,00EMPRESARIO INDIVIDUALMEDIATRANSPORTE, ARMAZENAGEM E CORREIOACIMA DE 1 ANOAMARELO2011-07-21NaN0.0101011.01.01.0100.00.0000.08bf37c178778e537b108e58bf20552abe10c3a7fae129b...5 a 107.27671263.063.063.0OUTROSTRANSPORTE TERRESTRENORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISTRANSPORTE ARMAZENAGEM E CORREIO23.001.0NaN1.01.00.01.0SERVIÇOMAMA50000.050000.00.00.0
7NaNNaNEMPRESARIO INDIVIDUALALTASERVICOS ADMINISTRATIVOSNaNNaN2018-10-09NaN0.010101NaNNaN1.0100.00.0010.00114fd3fbdc347c561843cde6aece12e8e53cb5d32c77d...<= 10.05205540.040.040.0OUTROSAGENCIAS DE VIAGENS OPERADORES TURISTICOS E SE...LESTE POTIGUARNATALATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...NaN01.01.0NaN1.00.01.0SERVIÇORNRNNaNNaN0.00.0
8DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00COOPERATIVAALTABENS DE CONSUMOACIMA DE 1 ANOAZUL2006-07-27247.880.0001000.01.01.0000.00.0010.06c45aabb849a760a3a7107c7a61262642f683feb8912a4...10 a 1512.26301436.036.036.0ENTIDADES EMPRESARIAISFABRICACAO DE PRODUTOS DIVERSOSCENTRO AMAZONENSEPARINTINSINDUSTRIAS DE TRANSFORMACAO24.002.0NaN1.02.00.01.0INDUSTRIAAMAM210000.0210000.00.00.0
9DE R$ 81.000,01 A R$ 360.000,00DE R$ 360.000,01 A R$ 1.500.000,00EMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOVERMELHO2004-10-301042.850.0000000.00.00.0000.00.0000.02fcd678d71b04ccb77644fff57706bdc7fcfbbec6b1926...15 a 2017.94246652.052.052.0OUTROSCOMERCIO VAREJISTAOESTE POTIGUARMOSSOROCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...54.031.0NaN1.01.00.0NaNCOMERCIORNRN210000.0840000.00.00.0

Last rows

de_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofl_anttfl_emailfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculoididade_emp_catidade_empresa_anosidade_maxima_sociosidade_media_sociosidade_minima_sociosnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciaqt_filiaisqt_sociosqt_socios_femininoqt_socios_masculinoqt_socios_pfqt_socios_pjqt_socios_st_regularsetorsg_ufsg_uf_matrizvl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_total_veiculos_leves_grupovl_total_veiculos_pesados_grupo
462288DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00EMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOAMARELO2005-11-031135.640.0001000.01.00.0000.00.0000.025fc6c2f86ea82180b19935893969ca5943af053cf4fa6...10 a 1514.586301NaNNaNNaNOUTROSCOMERCIO VAREJISTASUDOESTE AMAZONENSEJURUACOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...22.001.0NaNNaN1.00.0NaNCOMERCIOAMAM210000.0210000.00.00.0
462289DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00EMPRESARIO INDIVIDUALBAIXATEXTEISSEM INFORMACAOCINZA2018-02-191387.180.010101NaNNaN0.0000.00.0010.07217389b17042e97dd2b35899f375aabd40901c90f26b4...<= 10.68767122.022.00000022.0OUTROSFABRICACAO DE PRODUTOS TEXTEISNaNNaNINDUSTRIAS DE TRANSFORMACAONaN01.01.0NaN1.00.01.0INDUSTRIARORO210000.0210000.00.00.0
462290DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00SOCIEDADE EMPRESARIA LIMITADABAIXASERVICOS ADMINISTRATIVOSACIMA DE 1 ANOAZUL2009-08-04NaN0.0001000.01.01.0100.00.0010.06d1d4e188e3314878b59649c4f840e0ca141a3c03d5bfc...5 a 109.23835627.027.00000027.0ENTIDADES EMPRESARIAISSERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO...OESTE MARANHENSEIMPERATRIZATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...21.002.01.0NaN2.00.01.0SERVIÇOMAMA210000.0210000.00.00.0
462291DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00EMPRESARIO INDIVIDUALALTASERVICOS DIVERSOSACIMA DE 1 ANOAZUL2006-02-076022.810.0101000.01.01.0100.00.0001.0916d935f687e32f7c3efb21e982d908074d74eecf7ef4a...10 a 1512.72876744.044.00000044.0OUTROSOUTRAS ATIVIDADES DE SERVICOS PESSOAISCENTRO NORTE PIAUIENSETERESINAOUTRAS ATIVIDADES DE SERVICOS22.001.01.0NaN1.00.01.0SERVIÇOPIPI123638.4123638.41.00.0
462292DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00ENTIDADE SINDICALBAIXASERVICOS DIVERSOSACIMA DE 1 ANOAZUL2001-12-261286.040.0001000.00.01.0000.00.0001.0a29ac8a2e3a0bd8b806a7d62d135c806de7004dc088485...15 a 2016.849315NaNNaNNaNENTIDADES SEM FINS LUCRATIVOSATIVIDADES DE ORGANIZACOES ASSOCIATIVASNaNNaNOUTRAS ATIVIDADES DE SERVICOS23.00NaNNaNNaNNaNNaNNaNSERVIÇORORO210000.0210000.01.00.0
462293ATE R$ 81.000,00ATE R$ 81.000,00EMPRESARIO INDIVIDUALALTACOMERCIO E REPARACAO DE VEICULOSACIMA DE 1 ANOVERDE2015-07-28585.630.0101011.01.00.0000.00.0010.0469ee5fc984d0bb60aa2f40cda4d003d7c9b963d149ed3...1 a 53.25479531.031.00000031.0OUTROSCOMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E...AGRESTE POTIGUARBORBOREMA POTIGUARCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...22.001.0NaN1.01.00.01.0COMERCIORNRN50000.050000.00.00.0
462294DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00EMPRESARIO INDIVIDUALMUITO BAIXASERVICOS ADMINISTRATIVOSACIMA DE 1 ANOLARANJA2009-11-162429.890.0001000.00.01.0100.00.0000.0656f496e7e2fad708f0022d8ad97d2cb9344e839a5f3cb...5 a 108.953425NaNNaNNaNOUTROSSELECAO AGENCIAMENTO E LOCACAO DE MAO DE OBRACENTRO NORTE PIAUIENSETERESINAATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...23.00NaNNaNNaNNaNNaNNaNSERVIÇOPIPI210000.0210000.00.00.0
462295DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00ASSOCIACAO PRIVADAMEDIASERVICOS DE SAUDEACIMA DE 1 ANOAMARELO2005-11-033150.810.0001000.00.01.0100.00.0000.09b933a5cf2149d1338f00fb459d34a16b9b0f2e8d3e8e1...> 2020.74520574.074.00000074.0ENTIDADES SEM FINS LUCRATIVOSATIVIDADES DE ATENCAO A SAUDE HUMANANORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISSAUDE HUMANA E SERVICOS SOCIAIS23.001.0NaN1.01.00.01.0SERVIÇOMAMA210000.0210000.00.00.0
462296DE R$ 360.000,01 A R$ 1.500.000,00DE R$ 360.000,01 A R$ 1.500.000,00SOCIEDADE EMPRESARIA LIMITADAALTACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2016-11-302752.490.0101000.00.00.0000.00.0000.084db0f17467cf4f02439e01ade57150b6ac59d9dae53ed...1 a 51.90958939.031.66666725.0ENTIDADES EMPRESARIAISCOMERCIO VAREJISTANaNNaNCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...20.005.01.02.05.00.03.0COMERCIORORO432734.4432734.40.00.0
462297DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00EMPRESARIO INDIVIDUALBAIXATRANSPORTE, ARMAZENAGEM E CORREIOSEM INFORMACAOCINZA2018-01-10NaN0.010101NaNNaN1.0000.00.0010.03d43e934e150b86be1e67524f5ba1018b27da9ef25566d...<= 10.79726044.044.00000044.0OUTROSCORREIO E OUTRAS ATIVIDADES DE ENTREGANaNNaNTRANSPORTE ARMAZENAGEM E CORREIONaN01.0NaN1.01.00.01.0SERVIÇORORO210000.0210000.00.00.0